CREATE TABLE [dbo].[tr_ProjectSettings](
	[ProjectSettingId] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
	[ProjectId] [uniqueidentifier] NOT NULL,
	[ProjectEmail] [varchar](max) NOT NULL,
	[EmailServer] [varchar](max),
	[EmailPort] [int],
	[EmailUser] [varchar](max),
	[EmailPassword] [varchar](max)
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[tr_ProjectSettings] ADD  CONSTRAINT [DF_tr_ProjectSettings_ProjectSettingId]  DEFAULT (newid()) FOR [ProjectSettingId]
GO

